[dbo].[Survey]

Property	Value
Created	3:13:30 PM Friday, January 07, 2011
Last Modified	11:40:08 AM Monday, February 20, 2012

	Name	Data Type	Max Length (Bytes)	Default
$Cluster Primary Key PK_Survey: ID\SEQN$	ID	varchar(10)	10	('')
$Cluster Primary Key PK_Survey: ID\SEQN$	SEQN	int	4	((0))
	Year	datetime	8
	Age	int	4	((0))
	Employed	varchar(6)	6	('')
	HomeOwned	varchar(4)	4	('')
	NumChildren	int	4	((0))
	EdLevel	varchar(15)	15	('')
	NumAuto	int	4	((0))
	PBirth	varchar(50)	50	('')
	DOB	datetime	8
	eMail	varchar(60)	60	('')
	YMember	int	4	((0))
	StateChap	varchar(6)	6	('')
	MType	varchar(30)	30	('')
	AIncome	int	4	((0))
	CertDate	datetime	8
	TIME_STAMP	timestamp	8

	Name	Columns	Unique
$Cluster Primary Key PK_Survey: ID\SEQN$	PK_Survey	ID, SEQN

Type	Action	Owning Principal
Grant	Delete	IMIS
Grant	Insert	IMIS
Grant	References	IMIS
Grant	Select	IMIS
Grant	Update	IMIS

SQL Script

CREATE TABLE [dbo].[Survey]
(
[ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Survey_ID] DEFAULT (''),
[SEQN] [int] NOT NULL CONSTRAINT [DF_Survey_SEQN] DEFAULT ((0)),
[Year] [datetime] NULL,
[Age] [int] NOT NULL CONSTRAINT [DF_Survey_Age] DEFAULT ((0)),
[Employed] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Survey_Employed] DEFAULT (''),
[HomeOwned] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Survey_HomeOwned] DEFAULT (''),
[NumChildren] [int] NOT NULL CONSTRAINT [DF_Survey_NumChildren] DEFAULT ((0)),
[EdLevel] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Survey_EdLevel] DEFAULT (''),
[NumAuto] [int] NOT NULL CONSTRAINT [DF_Survey_NumAuto] DEFAULT ((0)),
[PBirth] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Survey_PBirth] DEFAULT (''),
[DOB] [datetime] NULL,
[eMail] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Survey_eMail] DEFAULT (''),
[YMember] [int] NOT NULL CONSTRAINT [DF_Survey_YMember] DEFAULT ((0)),
[StateChap] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Survey_StateChap] DEFAULT (''),
[MType] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Survey_MType] DEFAULT (''),
[AIncome] [int] NOT NULL CONSTRAINT [DF_Survey_AIncome] DEFAULT ((0)),
[CertDate] [datetime] NULL,
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[Survey] ADD CONSTRAINT [PK_Survey] PRIMARY KEY CLUSTERED ([ID], [SEQN]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[Survey] TO [IMIS]
GRANT SELECT ON  [dbo].[Survey] TO [IMIS]
GRANT INSERT ON  [dbo].[Survey] TO [IMIS]
GRANT DELETE ON  [dbo].[Survey] TO [IMIS]
GRANT UPDATE ON  [dbo].[Survey] TO [IMIS]
GO